
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[spAddressByCity] 
	@City Nvarchar(30)
AS
-- 주석을 넣어 봅시다.
select a.AddressID, a.AddressLine1, a.AddressLine2, a.City, sp.Name, a.PostalCode
from Person.Address as a 
join Person.StateProvince as sp
on a.StateProvinceID = sp.StateProvinceID
where a.City = @City;

GO
